Overview: Moving Statistics

Calculate statistics of the values of each field over a specified window. This window will move across rows of data, with the statistics being calculated either over a number of rows, i.e. index based window, or over a specified time period, i.e. time based window.

Statistics are calculated over the moving window as defined by using either the full data window or a partial data window, with the window size being determined by the good quality data threshold specified.

Properties

Category:

Transform

Performance risk:

Low performance risk

Knowledge required:

Working knowledge of the software.

 

Effect on datasets

How many datasets are required to perform this operation?

One

Does it create a new dataset?

Yes

Can you reconfigure this operation?

Yes

Can you apply this operation to a locked dataset?

Yes

Does it modify the current dataset in any way?

No

Requirements

  • For a index based window: dataset that contains at least one integer or double field.

  • For a time based window: dataset containing at least one integer or double field and one timestamp field.

Results

  • A new dataset containing the results of the selected statistics for the selected fields.

  • The resulting dataset will only contain the statistics of the selected fields, and none of the original values.

  • The original dataset will be unaffected by this operation.  


Related topics:

  

CSense 2023- Last updated: June 24,2025